Creating Dedicated Database or Schema

To function, erwin Data Intelligence Suite (DI Suite) requires a dedicated Microsoft SQL Server or Oracle database/schema. The SQL files for database tables necessary for erwin DI Suite are available in the erwin DI Suite installation package.

Creating a Dedicated Database or Schema in Microsoft SQL Server

To create a dedicated database in Microsoft SQL Server, follow these steps:

  1. Create a database/schema.
    For example, erwinDISuite.
  2. Unzip the erwin DI Suite installation package.
  3. Navigate to the SQL folder.
  4. Execute the erwinDISuite_SqlServer.sql file against the newly created erwinDISuite database.
    The database tables required for erwin DI Suite are created in your SQL Server database.
    Note: Ensure that you execute the <xx>_SQLServer.sql file against the newly created dedicated database and not on the master schema.

Once you have created a dedicated database/schema, create a dedicated database user account.

To create a database login role, follow these steps:

  1. In Microsoft SQL Server Management Studio > Security, right-click Logins.
  2. Click New Login.
    The Login - New window appears.
  3. Enter a Login name.
    For example, erwinDISuiteUser.
  4. Select SQL Server Authentication as the login mode.
  5. Enter a Password and confirm it.
  6. On the User Mapping page, do the following:
    1. In the Users mapped to this login section, select your dedicated database.
    2. In the Database role membership for <database> section, select the following roles:
      • public
      • db_owner
      • data_reader
      • data_writer
  7. Click OK.

Creating a Dedicated Database or Schema in Oracle

To create a dedicated schema in Oracle, follow these steps:

  1. Create a schema.
    For example, erwinDISuite.
  2. Assign the following roles/privileges to the user/schema.
    • Resource
    • Connect
    • Create Views
  3. Unzip the erwin DI Suite installation package.
  4. Navigate to the SQL folder.
  5. Execute the erwinDISuite_Oracle.sql file against the newly created erwinDISuite schema.
    The database tables required for erwin DI Suite are created in your Oracle schema.
    Note: Ensure that you create a dedicated schema in Oracle for AMM and that you execute the <xx>_Oracle.sql file against the newly created dedicated database.